1 <?php
2 include("../includes/config.php");
3 include("../includes/validate_data.php");
4 session_start();
5 if(isset($_SESSION['admin_login'])) {
6 if($_SESSION['admin_login'] == true) {
7 $id = $_GET['id'];
8 $query_selectRetailerDetails = "SELECT * FROM retailer WHERE retailer_id='$id'";
9 $result_selectRetailerDetails = mysqli_query($con,$query_selectRetailerDetails);
10 $row_selectRetailerDetails = mysqli_fetch_array($result_selectRetailerDetails);
11 $username = $password = $areacode = $phone = $email = $address = "";
12 $usernameErr = $passwordErr = $phoneErr = $emailErr = $requireErr = $confirmMessage = "";
13 $usernameHolder = $phoneHolder = $areacodeHolder = $emailHolder = $addressHolder = "";
14 $query_selectArea = "SELECT * FROM area";
15 $result_selectArea = mysqli_query($con,$query_selectArea);
16 if($_SERVER['REQUEST_METHOD'] == "POST") {
17 if(!empty($_POST['txtRetailerUname'])) {
18 $usernameHolder = $_POST['txtRetailerUname'];
19 $resultValidate_username = validate_username($_POST['txtRetailerUname']);
20 if($resultValidate_username == 1) {
21 $username = $_POST['txtRetailerUname'];
22 }
23 else{
24 $usernameErr = $resultValidate_username;
25 }
26 }
27 if(!empty($_POST['cmbAreaCode'])) {
28 $areacode = $_POST['cmbAreaCode'];
29 }
30 if(!empty($_POST['txtRetailerPhone'])) {
31 $phoneHolder = $_POST['txtRetailerPhone'];
32 $resultValidate_phone = validate_phone($_POST['txtRetailerPhone']);
33 if($resultValidate_phone == 1) {
34 $phone = $_POST['txtRetailerPhone'];
35 }
36 else {
37 $phoneErr = $resultValidate_phone;
38 }
39 }
40 if(!empty($_POST['txtRetailerEmail'])) {
41 $emailHolder = $_POST['txtRetailerEmail'];
42 $resultValidate_email = validate_email($_POST['txtRetailerEmail']);
43 if($resultValidate_email == 1) {
44 $email = $_POST['txtRetailerEmail'];
45 }
46 else {
47 $emailErr = $resultValidate_email;
48 }
49 }
50 if(!empty($_POST['txtRetailerAddress'])) {
51 $address = $_POST['txtRetailerAddress'];
52 $addressHolder = $_POST['txtRetailerAddress'];
53 }
54 if($username != null && $areacode != null && $phone != null) {
55 $query_UpdateRetailer = "UPDATE retailer SET username='$username',address='$address',area_id='$areacode',phone='$phone',email='$email' WHERE retailer_id='$id'";
56 if(mysqli_query($con,$query_UpdateRetailer)) {
57 echo "<script> alert(\"Retailer Updated Successfully\"); </script>";
58 header('Refresh:0;url=view_retailer.php');
59 }
60 else {
61 $requireErr = "Updating Retailer Failed";
62 }
63 }
64 else {
65 $requireErr = "* Valid Username, Password, Areacode & Email are compulsory";
66 }
67 }
68 }
69 else {
70 header('Location:../index.php');
71 }
72 }
73 else {
74 header('Location:../index.php');
75 }
76 ?>
77 <!DOCTYPE html>
78 <html>
79 <head>
80 <title> Edit Retailer </title>
81 <link rel="stylesheet" href="../includes/main_style.css" >
82 </head>
83 <body>
84 <?php
85 include("../includes/header.inc.php");
86 include("../includes/nav_admin.inc.php");
87 include("../includes/aside_admin.inc.php");
88 ?>
89 <section>
90 <h1>Edit Retailer</h1>
91 <form action="" method="POST" class="form">
92 <ul class="form-list">
93 <li>
94 <div class="label-block"> <label for="retailer:username">Username</label> </div>
95 <div class="input-box"> <input type="text" id="retailer:username" name="txtRetailerUname" placeholder="Username" value="<?php echo $row_selectRetailerDetails['username']; ?>" required /> </div> <span class="error_message"><?php echo $usernameErr; ?></span>
96 </li>
97 <li>
98 <div class="label-block"> <label for="retailer:areaCode">Area Code</label> </div>
99 <div class="input-box">
100 <select name="cmbAreaCode" id="retailer:areaCode">
101 <option value="" disabled>--- Select Area Code ---</option>
102 <?php while($row_selectArea = mysqli_fetch_array($result_selectArea)) { ?>
103 <option value="<?php echo $row_selectArea["area_id"]; ?>" <?php if($row_selectRetailerDetails['area_id'] == $row_selectArea["area_id"]){echo "selected";} ?>><?php echo $row_selectArea["area_code"]." (".$row_selectArea["area_name"].")"; ?></option>
104 <?php } ?>
105 </select>
106 </div>
107 </li>
108 <li>
109 <div class="label-block"> <label for="retailer:phone">Phone</label> </div>
110 <div class="input-box"> <input type="text" id="retailer:phone" name="txtRetailerPhone" placeholder="Phone" value="<?php echo $row_selectRetailerDetails['phone']; ?>" /> </div> <span class="error_message"><?php echo $phoneErr; ?></span>
111 </li>
112 <li>
113 <div class="label-block"> <label for="retailer:email">Email</label> </div>
114 <div class="input-box"> <input type="text" id="retailer:email" name="txtRetailerEmail" placeholder="Email" value="<?php echo $row_selectRetailerDetails['email']; ?>" required /> </div> <span class="error_message"><?php echo $emailErr; ?></span>
115 </li>
116 <li>
117 <div class="label-block"> <label for="retailer:address">Address</label> </div>
118 <div class="input-box"> <textarea type="text" id="retailer:address" name="txtRetailerAddress" placeholder="Address"><?php echo $row_selectRetailerDetails['address']; ?></textarea> </div>
119 </li>
120 <li>
121 <input type="submit" value="Update Retailer" class="submit_button" /> <span class="error_message"> <?php echo $requireErr; ?> </span><span class="confirm_message"> <?php echo $confirmMessage; ?> </span>
122 </li>
123 </ul>
124 </form>
125 </section>
126 <?php
127 include("../includes/footer.inc.php");
128 ?>
129 </body>
130 </html>